11111

COURSE INTRODUCTION AND APPLICATION INFORMATION


is.cs.ieu.edu.tr

Course Name
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
Fall
Prerequisites
None
Course Language
Course Type
Required
Course Level
-
Mode of Delivery -
Teaching Methods and Techniques of the Course
Course Coordinator -
Course Lecturer(s)
Assistant(s) -
Course Objectives
Learning Outcomes The students who succeeded in this course;
  • Will be able to understand basic benefits of information systems' usage
  • Will be able to determine data requirements of industrial organizations
  • Will be able to develop simple decision support systems
  • Will be able to use the functions of MS Excel and Visual Basic for MS Excel
  • Will be able to design and implement basic databases.
Course Description

 



Course Category

Core Courses
Major Area Courses
X
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Required Materials
1 Introduction, defining decision support systems (DSS’s) Chapter 1
2 Data, information, database, ER diagram Chapter 2
3 Spreadsheets, Introduction to cells, formatting Chapter 2
4 Spreadsheets, Introduction to cells, formatting Chapters 3-4-5
5 MS Excel Essentials: Referencing and Names, Functions and Formula, Charts Chapters 3-4-5
6 MS Excel Essentials: Pivot Tables, Statistical Analysis Chapters 6-7
7 MS Excel Essentials: Solver and Modeling, Working with Large Data Chapters 8-10
8 Midterm Exam All previous chapters, slides
9 Visual Basic for MS Excel: Visual Basic Environment, Recording Macros Chapters 11-12
10 Visual Basic for MS Excel: More on Objects, Variables Chapters 13-14
11 Visual Basic for MS Excel: Procedures, Programming Structures Chapters 15-16
12 Visual Basic for MS Excel: Arrays, User Interface Chapters 17-18
13 Visual Basic for MS Excel: Solver ReVisited Chapter 19
14 Case Studies: DSS Development Process, GUI Design and Programming Principles Chapters 22-23
15 General review and evaluation
16 Review of the Semester  
Course Notes/Textbooks Power point slides
Suggested Readings/Materials Using MIS, David M. Kroenke, Second Edition, 2009 Prentice Hall, ISBN: 9780138132484. Fundamentals of Database Systems, R. Elmasri, S.K. Navathe, Fifth Edition, 2006 AddisonWesley, ISBN: 9780321369574.

 

EVALUATION SYSTEM

Semester Activities Number Weigthing
Participation
Laboratory / Application
Field Work
Quizzes / Studio Critiques
6
30
Portfolio
Homework / Assignments
Presentation / Jury
Project
1
40
Seminar / Workshop
Oral Exam
Midterm
1
30
Final Exam
Total

Weighting of Semester Activities on the Final Grade
100
Weighting of End-of-Semester Activities on the Final Grade
Total

ECTS / WORKLOAD TABLE

Semester Activities Number Duration (Hours) Workload
Course Hours
(Including exam week: 16 x total hours)
16
2
32
Laboratory / Application Hours
(Including exam week: 16 x total hours)
16
2
Study Hours Out of Class
Field Work
Quizzes / Studio Critiques
6
6
Portfolio
Homework / Assignments
Presentation / Jury
Project
1
30
Seminar / Workshop
Oral Exam
Midterms
1
12
Final Exams
    Total
142

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
Program Competencies/Outcomes
* Contribution Level
1
2
3
4
5
1 Have the ability to optimize the managerial decisionmaking processes with the assessment of quality in production and service systems using Industrial Engineering tools and techniques such as simulation, optimization, probability and statistics, and analyze, interpret and assess data obtained. X
2 Be able to design integrated business systems with a systems approach based on the business requirements by generating and developing multiple alternatives X
3 Can identify, analyze and develop solutions based on scientific evidence to Industrial Engineering problems encountered in practice X
4 Have the ability to identify the problems in Industrial Engineering issues such as resource allocation, production planning and scheduling, quality control and assurance, financial analysis, and risk analysis, etc. and find the optimal solution by developing multiple solutions for these problems using quantitative analysis and critical thinking techniques with systems approach X
5 Be able to take responsibility for him/herself and for colleagues and employees to solve unpredicted complex problems encountered in practice individually or as a group member X
6 Have the ability to evaluate the knowledge and skills obtained in Industrial Engineering, be able to identify the topics which require improvement, and direct learning efforts to improve these points X
7 Can present and share knowledge, thoughts, and suggestions for solutions to problems related to the Industrial Engineering with colleagues using written and oral communication tools to both specialist and nonspecialist audiences supported by quantitative and qualitative data X
8 Ability to follow the developments in the field of Industrial Engineering and ability to communicate with colleagues using a foreign language. ("European Language Portfolio Global Scale", Level B1) X
9 Ability to use software programs related to Industrial Engineering and to have the knowledge and skills to learn and use software programs, information and communication technologies faced in practice. (“European Computer Driving License", Advanced Level) X
10 Understanding of social consciousness and to value social rights and justice. To value quality management and quality processes related to environment and job safety X
11 Ability to consider social, scientific, and ethical values in data collection, interpretation, and implementation stages of the Industrial Engineering problems and projects X

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

 

İzmir Ekonomi Üniversitesi | Sakarya Caddesi No:156, 35330 Balçova - İZMİR Tel: +90 232 279 25 25 | webmaster@ieu.edu.tr | YBS 2010